Sort a Data Grid Using the Custom Order Column

You can manually specify numeric values to use to sort the data using the Order column.

1. In the data grid you want to sort, click Show or hide custom sort order.

The Order column appears at the rightmost of the data grid.

2. Type the values you want to use to sort the data in the field for each row.

Note: You can use any numeric values greater than or equal to zero in the Order column, including decimals. Multiple rows in the data grid can have the same value.

3. To sort in ascending order, click the Order heading.
4. To sort in descending order, click the Order heading a second time.

Notes:

• If you enter the same order value for more than one row, and then sort using the Order column, items with the same order value are sorted using the default sort setting for that data grid.
• Blank values are sorted to the bottom of the data grid, when sorting in ascending order. Knowing that blank values are sorted to the bottom of the grid means you can type values in only the rows that you want to display at the top of the data grid.